Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 9994 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 10.5 MiB |
| Average record size in memory | 1.1 KiB |
Variable types
| Categorical | 15 |
|---|---|
| DateTime | 2 |
| Numeric | 10 |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
order_id has a high cardinality: 5009 distinct values | High cardinality |
customer_id has a high cardinality: 793 distinct values | High cardinality |
customer_name has a high cardinality: 793 distinct values | High cardinality |
city has a high cardinality: 531 distinct values | High cardinality |
product_id has a high cardinality: 1862 distinct values | High cardinality |
product_name has a high cardinality: 1850 distinct values | High cardinality |
sales is highly overall correlated with profit and 3 other fields | High correlation |
discount is highly overall correlated with profit and 1 other fields | High correlation |
profit is highly overall correlated with sales and 2 other fields | High correlation |
no_of_days_for_shipping is highly overall correlated with ship_mode | High correlation |
sale_price_per_unit is highly overall correlated with sales and 3 other fields | High correlation |
profit_per_unit is highly overall correlated with discount and 2 other fields | High correlation |
purchase_price_per_unit is highly overall correlated with sales and 2 other fields | High correlation |
purchase_price is highly overall correlated with sales and 2 other fields | High correlation |
month is highly overall correlated with month_name | High correlation |
ship_mode is highly overall correlated with no_of_days_for_shipping | High correlation |
state is highly overall correlated with region | High correlation |
region is highly overall correlated with state | High correlation |
category is highly overall correlated with sub-category | High correlation |
sub-category is highly overall correlated with category | High correlation |
month_name is highly overall correlated with month | High correlation |
discount has 4798 (48.0%) zeros | Zeros |
no_of_days_for_shipping has 519 (5.2%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-13 02:03:50.441492 |
|---|---|
| Analysis finished | 2023-06-13 02:04:17.928480 |
| Duration | 27.49 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
order_id
Categorical
| Distinct | 5009 |
|---|---|
| Distinct (%) | 50.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| CA-2017-100111 | 14 |
|---|---|
| CA-2017-157987 | 12 |
| CA-2016-165330 | 11 |
| US-2016-108504 | 11 |
| CA-2015-131338 | 10 |
| Other values (5004) |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Characters and Unicode
| Total characters | 139916 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2538 ? |
|---|---|
| Unique (%) | 25.4% |
Sample
| 1st row | CA-2016-152156 |
|---|---|
| 2nd row | CA-2016-152156 |
| 3rd row | CA-2016-138688 |
| 4th row | US-2015-108966 |
| 5th row | US-2015-108966 |
Common Values
| Value | Count | Frequency (%) |
| CA-2017-100111 | 14 | 0.1% |
| CA-2017-157987 | 12 | 0.1% |
| CA-2016-165330 | 11 | 0.1% |
| US-2016-108504 | 11 | 0.1% |
| CA-2015-131338 | 10 | 0.1% |
| CA-2016-105732 | 10 | 0.1% |
| US-2015-126977 | 10 | 0.1% |
| US-2016-114013 | 9 | 0.1% |
| CA-2014-106439 | 9 | 0.1% |
| CA-2016-145177 | 9 | 0.1% |
| Other values (4999) | 9889 |
Length
| Value | Count | Frequency (%) |
| ca-2017-100111 | 14 | 0.1% |
| ca-2017-157987 | 12 | 0.1% |
| ca-2016-165330 | 11 | 0.1% |
| us-2016-108504 | 11 | 0.1% |
| ca-2015-131338 | 10 | 0.1% |
| ca-2016-105732 | 10 | 0.1% |
| us-2015-126977 | 10 | 0.1% |
| us-2015-163433 | 9 | 0.1% |
| ca-2017-140949 | 9 | 0.1% |
| ca-2015-158421 | 9 | 0.1% |
| Other values (4999) | 9889 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| C | 8308 | 5.9% |
| A | 8308 | 5.9% |
| 6 | 7904 | 5.6% |
| 7 | 7438 | 5.3% |
| 4 | 7400 | 5.3% |
| 5 | 7338 | 5.2% |
| Other values (5) | 16849 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 99940 | |
| Dash Punctuation | 19988 | 14.3% |
| Uppercase Letter | 19988 | 14.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| 0 | 15492 | |
| 2 | 15381 | |
| 6 | 7904 | 7.9% |
| 7 | 7438 | 7.4% |
| 4 | 7400 | 7.4% |
| 5 | 7338 | 7.3% |
| 3 | 5449 | 5.5% |
| 8 | 4042 | 4.0% |
| 9 | 3986 | 4.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8308 | |
| A | 8308 | |
| U | 1686 | 8.4% |
| S | 1686 | 8.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19988 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 119928 | |
| Latin | 19988 | 14.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| 6 | 7904 | 6.6% |
| 7 | 7438 | 6.2% |
| 4 | 7400 | 6.2% |
| 5 | 7338 | 6.1% |
| 3 | 5449 | 4.5% |
| 8 | 4042 | 3.4% |
Latin
| Value | Count | Frequency (%) |
| C | 8308 | |
| A | 8308 | |
| U | 1686 | 8.4% |
| S | 1686 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 139916 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 25510 | |
| - | 19988 | |
| 0 | 15492 | |
| 2 | 15381 | |
| C | 8308 | 5.9% |
| A | 8308 | 5.9% |
| 6 | 7904 | 5.6% |
| 7 | 7438 | 5.3% |
| 4 | 7400 | 5.3% |
| 5 | 7338 | 5.2% |
| Other values (5) | 16849 |
order_date
Date
| Distinct | 1237 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 414.2 KiB |
| Minimum | 2014-01-03 00:00:00 |
|---|---|
| Maximum | 2017-12-30 00:00:00 |
ship_date
Date
| Distinct | 1329 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 414.2 KiB |
| Minimum | 2014-01-07 00:00:00 |
|---|---|
| Maximum | 2017-12-31 00:00:00 |
ship_mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1017.6 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 543 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.823094 |
| Min length | 8 |
Characters and Unicode
| Total characters | 128154 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Second Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Second Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 5968 | |
| Second Class | 1945 | 19.5% |
| First Class | 1538 | 15.4% |
| Same Day | 543 | 5.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 9451 | |
| standard | 5968 | |
| second | 1945 | 9.7% |
| first | 1538 | 7.7% |
| same | 543 | 2.7% |
| day | 543 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 98172 | |
| Uppercase Letter | 19988 | 15.6% |
| Space Separator | 9994 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| l | 9451 | |
| n | 7913 | 8.1% |
| r | 7506 | 7.6% |
| t | 7506 | 7.6% |
| e | 2488 | 2.5% |
| c | 1945 | 2.0% |
| o | 1945 | 2.0% |
| Other values (3) | 2624 | 2.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 9451 | |
| S | 8456 | |
| F | 1538 | 7.7% |
| D | 543 | 2.7% |
Space Separator
| Value | Count | Frequency (%) |
| 9994 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 118160 | |
| Common | 9994 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 7.2% |
| n | 7913 | 6.7% |
| r | 7506 | 6.4% |
| t | 7506 | 6.4% |
| e | 2488 | 2.1% |
| Other values (7) | 8595 | 7.3% |
Common
| Value | Count | Frequency (%) |
| 9994 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 128154 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 22473 | |
| s | 20440 | |
| d | 13881 | |
| 9994 | ||
| l | 9451 | |
| C | 9451 | |
| S | 8456 | 6.6% |
| n | 7913 | 6.2% |
| r | 7506 | 5.9% |
| t | 7506 | 5.9% |
| Other values (8) | 11083 |
customer_id
Categorical
| Distinct | 793 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 970.5 KiB |
| WB-21850 | 37 |
|---|---|
| JL-15835 | 34 |
| MA-17560 | 34 |
| PP-18955 | 34 |
| CK-12205 | 32 |
| Other values (788) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 79952 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | CG-12520 |
|---|---|
| 2nd row | CG-12520 |
| 3rd row | DV-13045 |
| 4th row | SO-20335 |
| 5th row | SO-20335 |
Common Values
| Value | Count | Frequency (%) |
| WB-21850 | 37 | 0.4% |
| JL-15835 | 34 | 0.3% |
| MA-17560 | 34 | 0.3% |
| PP-18955 | 34 | 0.3% |
| CK-12205 | 32 | 0.3% |
| SV-20365 | 32 | 0.3% |
| JD-15895 | 32 | 0.3% |
| EH-13765 | 32 | 0.3% |
| ZC-21910 | 31 | 0.3% |
| EP-13915 | 31 | 0.3% |
| Other values (783) | 9665 |
Length
| Value | Count | Frequency (%) |
| wb-21850 | 37 | 0.4% |
| ma-17560 | 34 | 0.3% |
| pp-18955 | 34 | 0.3% |
| jl-15835 | 34 | 0.3% |
| ck-12205 | 32 | 0.3% |
| sv-20365 | 32 | 0.3% |
| jd-15895 | 32 | 0.3% |
| eh-13765 | 32 | 0.3% |
| zc-21910 | 31 | 0.3% |
| ep-13915 | 31 | 0.3% |
| Other values (783) | 9665 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | 10.7% |
| 5 | 7865 | 9.8% |
| 2 | 4682 | 5.9% |
| 7 | 2931 | 3.7% |
| 6 | 2909 | 3.6% |
| 9 | 2904 | 3.6% |
| 8 | 2818 | 3.5% |
| 3 | 2779 | 3.5% |
| Other values (30) | 22623 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 49970 | |
| Uppercase Letter | 19945 | 24.9% |
| Dash Punctuation | 9994 | 12.5% |
| Lowercase Letter | 43 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1798 | 9.0% |
| C | 1725 | 8.6% |
| M | 1712 | 8.6% |
| B | 1642 | 8.2% |
| D | 1296 | 6.5% |
| A | 1227 | 6.2% |
| J | 1134 | 5.7% |
| P | 1105 | 5.5% |
| H | 968 | 4.9% |
| K | 932 | 4.7% |
| Other values (16) | 6406 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| 0 | 8532 | |
| 5 | 7865 | |
| 2 | 4682 | 9.4% |
| 7 | 2931 | 5.9% |
| 6 | 2909 | 5.8% |
| 9 | 2904 | 5.8% |
| 8 | 2818 | 5.6% |
| 3 | 2779 | 5.6% |
| 4 | 2635 | 5.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 29 | |
| o | 8 | 18.6% |
| l | 6 | 14.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 9994 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59964 | |
| Latin | 19988 | 25.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 1798 | 9.0% |
| C | 1725 | 8.6% |
| M | 1712 | 8.6% |
| B | 1642 | 8.2% |
| D | 1296 | 6.5% |
| A | 1227 | 6.1% |
| J | 1134 | 5.7% |
| P | 1105 | 5.5% |
| H | 968 | 4.8% |
| K | 932 | 4.7% |
| Other values (19) | 6449 |
Common
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | |
| 5 | 7865 | |
| 2 | 4682 | 7.8% |
| 7 | 2931 | 4.9% |
| 6 | 2909 | 4.9% |
| 9 | 2904 | 4.8% |
| 8 | 2818 | 4.7% |
| 3 | 2779 | 4.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79952 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 11915 | |
| - | 9994 | |
| 0 | 8532 | 10.7% |
| 5 | 7865 | 9.8% |
| 2 | 4682 | 5.9% |
| 7 | 2931 | 3.7% |
| 6 | 2909 | 3.6% |
| 9 | 2904 | 3.6% |
| 8 | 2818 | 3.5% |
| 3 | 2779 | 3.5% |
| Other values (30) | 22623 |
customer_name
Categorical
| Distinct | 793 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1022.4 KiB |
| William Brown | 37 |
|---|---|
| John Lee | 34 |
| Matt Abelman | 34 |
| Paul Prost | 34 |
| Chloris Kastensmidt | 32 |
| Other values (788) |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.960676 |
| Min length | 7 |
Characters and Unicode
| Total characters | 129529 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Claire Gute |
|---|---|
| 2nd row | Claire Gute |
| 3rd row | Darrin Van Huff |
| 4th row | Sean O'Donnell |
| 5th row | Sean O'Donnell |
Common Values
| Value | Count | Frequency (%) |
| William Brown | 37 | 0.4% |
| John Lee | 34 | 0.3% |
| Matt Abelman | 34 | 0.3% |
| Paul Prost | 34 | 0.3% |
| Chloris Kastensmidt | 32 | 0.3% |
| Seth Vernon | 32 | 0.3% |
| Jonathan Doherty | 32 | 0.3% |
| Edward Hooks | 32 | 0.3% |
| Zuschuss Carroll | 31 | 0.3% |
| Emily Phan | 31 | 0.3% |
| Other values (783) | 9665 |
Length
| Value | Count | Frequency (%) |
| michael | 120 | 0.6% |
| frank | 112 | 0.6% |
| john | 107 | 0.5% |
| patrick | 96 | 0.5% |
| brian | 93 | 0.5% |
| stewart | 93 | 0.5% |
| paul | 92 | 0.5% |
| ken | 91 | 0.5% |
| rick | 91 | 0.5% |
| matt | 86 | 0.4% |
| Other values (901) | 19072 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (47) | 45608 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 98856 | |
| Uppercase Letter | 20461 | 15.8% |
| Space Separator | 10059 | 7.8% |
| Other Punctuation | 124 | 0.1% |
| Dash Punctuation | 29 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 12011 | |
| e | 11836 | |
| n | 10241 | |
| r | 9530 | |
| i | 7919 | 8.0% |
| l | 6494 | 6.6% |
| o | 5850 | 5.9% |
| t | 5435 | 5.5% |
| s | 4546 | 4.6% |
| h | 3857 | 3.9% |
| Other values (18) | 21137 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1830 | 8.9% |
| S | 1798 | 8.8% |
| M | 1749 | 8.5% |
| B | 1696 | 8.3% |
| D | 1325 | 6.5% |
| A | 1282 | 6.3% |
| J | 1134 | 5.5% |
| P | 1105 | 5.4% |
| H | 1005 | 4.9% |
| K | 964 | 4.7% |
| Other values (16) | 6573 |
Space Separator
| Value | Count | Frequency (%) |
| 10059 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 124 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119317 | |
| Common | 10212 | 7.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 12011 | 10.1% |
| e | 11836 | 9.9% |
| n | 10241 | 8.6% |
| r | 9530 | 8.0% |
| i | 7919 | 6.6% |
| l | 6494 | 5.4% |
| o | 5850 | 4.9% |
| t | 5435 | 4.6% |
| s | 4546 | 3.8% |
| h | 3857 | 3.2% |
| Other values (44) | 41598 |
Common
| Value | Count | Frequency (%) |
| 10059 | ||
| ' | 124 | 1.2% |
| - | 29 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 129440 | |
| None | 89 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 12011 | 9.3% |
| e | 11836 | 9.1% |
| n | 10241 | 7.9% |
| 10059 | 7.8% | |
| r | 9530 | 7.4% |
| i | 7919 | 6.1% |
| l | 6494 | 5.0% |
| o | 5850 | 4.5% |
| t | 5435 | 4.2% |
| s | 4546 | 3.5% |
| Other values (44) | 45519 |
None
| Value | Count | Frequency (%) |
| ö | 61 | |
| ä | 23 | 25.8% |
| ü | 5 | 5.6% |
segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 978.7 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8374024 |
| Min length | 8 |
Characters and Unicode
| Total characters | 88321 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Corporate |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 5191 | |
| Corporate | 3020 | |
| Home Office | 1783 | 17.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 5191 | |
| corporate | 3020 | |
| home | 1783 | 15.1% |
| office | 1783 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 74761 | |
| Uppercase Letter | 11777 | 13.3% |
| Space Separator | 1783 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| m | 6974 | |
| n | 5191 | 6.9% |
| s | 5191 | 6.9% |
| u | 5191 | 6.9% |
| f | 3566 | 4.8% |
| t | 3020 | 4.0% |
| p | 3020 | 4.0% |
| Other values (3) | 6586 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 8211 | |
| H | 1783 | 15.1% |
| O | 1783 | 15.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1783 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 86538 | |
| Common | 1783 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 6.0% |
| s | 5191 | 6.0% |
| u | 5191 | 6.0% |
| f | 3566 | 4.1% |
| t | 3020 | 3.5% |
| Other values (6) | 13172 |
Common
| Value | Count | Frequency (%) |
| 1783 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 88321 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 13014 | |
| e | 11777 | |
| r | 11231 | |
| C | 8211 | |
| m | 6974 | |
| n | 5191 | 5.9% |
| s | 5191 | 5.9% |
| u | 5191 | 5.9% |
| f | 3566 | 4.0% |
| t | 3020 | 3.4% |
| Other values (7) | 14955 |
city
Categorical
| Distinct | 531 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 983.5 KiB |
| New York City | |
|---|---|
| Los Angeles | |
| Philadelphia | 537 |
| San Francisco | 510 |
| Seattle | 428 |
| Other values (526) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 9.3306984 |
| Min length | 4 |
Characters and Unicode
| Total characters | 93251 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 70 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | Henderson |
|---|---|
| 2nd row | Henderson |
| 3rd row | Los Angeles |
| 4th row | Fort Lauderdale |
| 5th row | Fort Lauderdale |
Common Values
| Value | Count | Frequency (%) |
| New York City | 915 | 9.2% |
| Los Angeles | 747 | 7.5% |
| Philadelphia | 537 | 5.4% |
| San Francisco | 510 | 5.1% |
| Seattle | 428 | 4.3% |
| Houston | 377 | 3.8% |
| Chicago | 314 | 3.1% |
| Columbus | 222 | 2.2% |
| San Diego | 170 | 1.7% |
| Springfield | 163 | 1.6% |
| Other values (521) | 5611 |
Length
| Value | Count | Frequency (%) |
| city | 994 | 7.0% |
| new | 937 | 6.6% |
| york | 920 | 6.5% |
| san | 805 | 5.7% |
| los | 747 | 5.2% |
| angeles | 747 | 5.2% |
| philadelphia | 537 | 3.8% |
| francisco | 510 | 3.6% |
| seattle | 428 | 3.0% |
| houston | 377 | 2.6% |
| Other values (555) | 7234 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 74773 | |
| Uppercase Letter | 14236 | 15.3% |
| Space Separator | 4242 | 4.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 8719 | |
| a | 7591 | |
| o | 7499 | |
| i | 6229 | 8.3% |
| n | 6199 | 8.3% |
| l | 5986 | 8.0% |
| s | 4699 | 6.3% |
| r | 4468 | 6.0% |
| t | 4438 | 5.9% |
| c | 2393 | 3.2% |
| Other values (16) | 16552 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2085 | |
| S | 1740 | |
| L | 1295 | |
| A | 1242 | |
| N | 1134 | |
| P | 1013 | 7.1% |
| Y | 940 | 6.6% |
| F | 794 | 5.6% |
| D | 627 | 4.4% |
| H | 617 | 4.3% |
| Other values (14) | 2749 |
Space Separator
| Value | Count | Frequency (%) |
| 4242 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 89009 | |
| Common | 4242 | 4.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 8719 | 9.8% |
| a | 7591 | 8.5% |
| o | 7499 | 8.4% |
| i | 6229 | 7.0% |
| n | 6199 | 7.0% |
| l | 5986 | 6.7% |
| s | 4699 | 5.3% |
| r | 4468 | 5.0% |
| t | 4438 | 5.0% |
| c | 2393 | 2.7% |
| Other values (40) | 30788 |
Common
| Value | Count | Frequency (%) |
| 4242 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 93251 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 8719 | 9.4% |
| a | 7591 | 8.1% |
| o | 7499 | 8.0% |
| i | 6229 | 6.7% |
| n | 6199 | 6.6% |
| l | 5986 | 6.4% |
| s | 4699 | 5.0% |
| r | 4468 | 4.8% |
| t | 4438 | 4.8% |
| 4242 | 4.5% | |
| Other values (41) | 33181 |
state
Categorical
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 975.3 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Pennsylvania | |
| Washington | |
| Other values (44) |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.4871923 |
| Min length | 4 |
Characters and Unicode
| Total characters | 84821 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | California |
| 4th row | Florida |
| 5th row | Florida |
Common Values
| Value | Count | Frequency (%) |
| California | 2001 | |
| New York | 1128 | 11.3% |
| Texas | 985 | 9.9% |
| Pennsylvania | 587 | 5.9% |
| Washington | 506 | 5.1% |
| Illinois | 492 | 4.9% |
| Ohio | 469 | 4.7% |
| Florida | 383 | 3.8% |
| Michigan | 255 | 2.6% |
| North Carolina | 249 | 2.5% |
| Other values (39) | 2939 |
Length
| Value | Count | Frequency (%) |
| california | 2001 | |
| new | 1322 | 11.3% |
| york | 1128 | 9.6% |
| texas | 985 | 8.4% |
| pennsylvania | 587 | 5.0% |
| washington | 506 | 4.3% |
| illinois | 492 | 4.2% |
| ohio | 469 | 4.0% |
| florida | 383 | 3.3% |
| carolina | 291 | 2.5% |
| Other values (43) | 3542 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 71413 | |
| Uppercase Letter | 11696 | 13.8% |
| Space Separator | 1712 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | |
| o | 7323 | |
| r | 5544 | |
| e | 5051 | |
| l | 4822 | |
| s | 4604 | |
| f | 2011 | 2.8% |
| h | 1898 | 2.7% |
| Other values (14) | 11417 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 2566 | |
| N | 1655 | |
| T | 1168 | |
| Y | 1128 | |
| M | 763 | 6.5% |
| I | 748 | 6.4% |
| O | 659 | 5.6% |
| W | 621 | 5.3% |
| P | 587 | 5.0% |
| F | 383 | 3.3% |
| Other values (11) | 1418 |
Space Separator
| Value | Count | Frequency (%) |
| 1712 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 83109 | |
| Common | 1712 | 2.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.7% |
| o | 7323 | 8.8% |
| r | 5544 | 6.7% |
| e | 5051 | 6.1% |
| l | 4822 | 5.8% |
| s | 4604 | 5.5% |
| C | 2566 | 3.1% |
| f | 2011 | 2.4% |
| Other values (35) | 22445 |
Common
| Value | Count | Frequency (%) |
| 1712 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 84821 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 10758 | |
| i | 9895 | |
| n | 8090 | 9.5% |
| o | 7323 | 8.6% |
| r | 5544 | 6.5% |
| e | 5051 | 6.0% |
| l | 4822 | 5.7% |
| s | 4604 | 5.4% |
| C | 2566 | 3.0% |
| f | 2011 | 2.4% |
| Other values (36) | 24157 |
region
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 939.9 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8594156 |
| Min length | 4 |
Characters and Unicode
| Total characters | 48565 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | West |
| 4th row | South |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 3203 | |
| East | 2848 | |
| Central | 2323 | |
| South | 1620 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 3203 | |
| east | 2848 | |
| central | 2323 | |
| south | 1620 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 38571 | |
| Uppercase Letter | 9994 | 20.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| n | 2323 | 6.0% |
| r | 2323 | 6.0% |
| l | 2323 | 6.0% |
| o | 1620 | 4.2% |
| u | 1620 | 4.2% |
| h | 1620 | 4.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 3203 | |
| E | 2848 | |
| C | 2323 | |
| S | 1620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 48565 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48565 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 9994 | |
| s | 6051 | |
| e | 5526 | |
| a | 5171 | |
| W | 3203 | 6.6% |
| E | 2848 | 5.9% |
| C | 2323 | 4.8% |
| n | 2323 | 4.8% |
| r | 2323 | 4.8% |
| l | 2323 | 4.8% |
| Other values (4) | 6480 |
product_id
Categorical
| Distinct | 1862 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| OFF-PA-10001970 | 19 |
|---|---|
| TEC-AC-10003832 | 18 |
| FUR-FU-10004270 | 16 |
| FUR-CH-10001146 | 15 |
| TEC-AC-10003628 | 15 |
| Other values (1857) |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 149910 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 91 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | FUR-BO-10001798 |
|---|---|
| 2nd row | FUR-CH-10000454 |
| 3rd row | OFF-LA-10000240 |
| 4th row | FUR-TA-10000577 |
| 5th row | OFF-ST-10000760 |
Common Values
| Value | Count | Frequency (%) |
| OFF-PA-10001970 | 19 | 0.2% |
| TEC-AC-10003832 | 18 | 0.2% |
| FUR-FU-10004270 | 16 | 0.2% |
| FUR-CH-10001146 | 15 | 0.2% |
| TEC-AC-10003628 | 15 | 0.2% |
| FUR-CH-10002647 | 15 | 0.2% |
| TEC-AC-10002049 | 15 | 0.2% |
| OFF-BI-10004632 | 14 | 0.1% |
| OFF-BI-10001524 | 14 | 0.1% |
| FUR-CH-10002880 | 14 | 0.1% |
| Other values (1852) | 9839 |
Length
| Value | Count | Frequency (%) |
| off-pa-10001970 | 19 | 0.2% |
| tec-ac-10003832 | 18 | 0.2% |
| fur-fu-10004270 | 16 | 0.2% |
| fur-ch-10001146 | 15 | 0.2% |
| tec-ac-10003628 | 15 | 0.2% |
| fur-ch-10002647 | 15 | 0.2% |
| tec-ac-10002049 | 15 | 0.2% |
| off-pa-10002377 | 14 | 0.1% |
| fur-ch-10003774 | 14 | 0.1% |
| off-bi-10002026 | 14 | 0.1% |
| Other values (1852) | 9839 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| F | 15347 | |
| 1 | 14995 | |
| O | 6322 | 4.2% |
| 2 | 4862 | 3.2% |
| 4 | 4831 | 3.2% |
| 3 | 4805 | 3.2% |
| A | 4422 | 2.9% |
| 5 | 3401 | 2.3% |
| Other values (17) | 35885 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 79952 | |
| Uppercase Letter | 49970 | |
| Dash Punctuation | 19988 | 13.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 15347 | |
| O | 6322 | |
| A | 4422 | 8.8% |
| C | 3307 | 6.6% |
| U | 3268 | 6.5% |
| T | 3012 | 6.0% |
| R | 2917 | 5.8% |
| P | 2725 | 5.5% |
| E | 2101 | 4.2% |
| B | 1751 | 3.5% |
| Other values (6) | 4798 | 9.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| 1 | 14995 | |
| 2 | 4862 | 6.1% |
| 4 | 4831 | 6.0% |
| 3 | 4805 | 6.0% |
| 5 | 3401 | 4.3% |
| 7 | 3103 | 3.9% |
| 9 | 3051 | 3.8% |
| 6 | 2999 | 3.8% |
| 8 | 2853 | 3.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19988 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 99940 | |
| Latin | 49970 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| F | 15347 | |
| O | 6322 | |
| A | 4422 | 8.8% |
| C | 3307 | 6.6% |
| U | 3268 | 6.5% |
| T | 3012 | 6.0% |
| R | 2917 | 5.8% |
| P | 2725 | 5.5% |
| E | 2101 | 4.2% |
| B | 1751 | 3.5% |
| Other values (6) | 4798 | 9.6% |
Common
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| 1 | 14995 | |
| 2 | 4862 | 4.9% |
| 4 | 4831 | 4.8% |
| 3 | 4805 | 4.8% |
| 5 | 3401 | 3.4% |
| 7 | 3103 | 3.1% |
| 9 | 3051 | 3.1% |
| 6 | 2999 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 149910 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 35052 | |
| - | 19988 | |
| F | 15347 | |
| 1 | 14995 | |
| O | 6322 | 4.2% |
| 2 | 4862 | 3.2% |
| 4 | 4831 | 3.2% |
| 3 | 4805 | 3.2% |
| A | 4422 | 2.9% |
| 5 | 3401 | 2.3% |
| Other values (17) | 35885 |
category
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1017.4 KiB |
| Office Supplies | |
|---|---|
| Furniture | |
| Technology |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 12.802582 |
| Min length | 9 |
Characters and Unicode
| Total characters | 127949 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Office Supplies |
| 4th row | Furniture |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Office Supplies | 6026 | |
| Furniture | 2121 | 21.2% |
| Technology | 1847 | 18.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 6026 | |
| supplies | 6026 | |
| furniture | 2121 | 13.2% |
| technology | 1847 | 11.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 105903 | |
| Uppercase Letter | 16020 | 12.5% |
| Space Separator | 6026 | 4.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | |
| c | 7873 | |
| l | 7873 | |
| s | 6026 | 5.7% |
| r | 4242 | 4.0% |
| n | 3968 | 3.7% |
| Other values (5) | 11356 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 6026 | |
| S | 6026 | |
| F | 2121 | 13.2% |
| T | 1847 | 11.5% |
Space Separator
| Value | Count | Frequency (%) |
| 6026 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 121923 | |
| Common | 6026 | 4.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | |
| c | 7873 | 6.5% |
| l | 7873 | 6.5% |
| O | 6026 | 4.9% |
| s | 6026 | 4.9% |
| S | 6026 | 4.9% |
| Other values (9) | 23534 |
Common
| Value | Count | Frequency (%) |
| 6026 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127949 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 16020 | |
| i | 14173 | |
| p | 12052 | |
| f | 12052 | |
| u | 10268 | 8.0% |
| c | 7873 | 6.2% |
| l | 7873 | 6.2% |
| O | 6026 | 4.7% |
| s | 6026 | 4.7% |
| S | 6026 | 4.7% |
| Other values (10) | 29560 |
sub-category
Categorical
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 962.6 KiB |
| Binders | |
|---|---|
| Paper | |
| Furnishings | |
| Phones | |
| Storage | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 7.191715 |
| Min length | 3 |
Characters and Unicode
| Total characters | 71874 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Labels |
| 4th row | Tables |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Binders | 1523 | |
| Paper | 1370 | |
| Furnishings | 957 | |
| Phones | 889 | |
| Storage | 846 | |
| Art | 796 | |
| Accessories | 775 | |
| Chairs | 617 | |
| Appliances | 466 | 4.7% |
| Labels | 364 | 3.6% |
| Other values (7) | 1391 |
Length
| Value | Count | Frequency (%) |
| binders | 1523 | |
| paper | 1370 | |
| furnishings | 957 | |
| phones | 889 | |
| storage | 846 | |
| art | 796 | |
| accessories | 775 | |
| chairs | 617 | |
| appliances | 466 | 4.7% |
| labels | 364 | 3.6% |
| Other values (7) | 1391 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 61880 | |
| Uppercase Letter | 9994 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | |
| i | 5668 | |
| n | 5378 | |
| a | 4542 | |
| o | 3288 | 5.3% |
| p | 3004 | 4.9% |
| h | 2578 | 4.2% |
| c | 2359 | 3.8% |
| Other values (8) | 9090 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2259 | |
| A | 2037 | |
| B | 1751 | |
| F | 1174 | |
| S | 1036 | |
| C | 685 | 6.9% |
| L | 364 | 3.6% |
| T | 319 | 3.2% |
| E | 254 | 2.5% |
| M | 115 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 71874 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71874 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 9934 | |
| e | 8870 | |
| r | 7169 | 10.0% |
| i | 5668 | 7.9% |
| n | 5378 | 7.5% |
| a | 4542 | 6.3% |
| o | 3288 | 4.6% |
| p | 3004 | 4.2% |
| h | 2578 | 3.6% |
| c | 2359 | 3.3% |
| Other values (18) | 19084 |
product_name
Categorical
| Distinct | 1850 |
|---|---|
| Distinct (%) | 18.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| Staple envelope | 48 |
|---|---|
| Staples | 46 |
| Easy-staple paper | 46 |
| Avery Non-Stick Binders | 20 |
| Staples in misc. colors | 19 |
| Other values (1845) |
Length
| Max length | 127 |
|---|---|
| Median length | 78 |
| Mean length | 36.91605 |
| Min length | 5 |
Characters and Unicode
| Total characters | 368939 |
|---|---|
| Distinct characters | 85 |
| Distinct categories | 11 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 91 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | Bush Somerset Collection Bookcase |
|---|---|
| 2nd row | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back |
| 3rd row | Self-Adhesive Address Labels for Typewriters by Universal |
| 4th row | Bretford CR4500 Series Slim Rectangular Table |
| 5th row | Eldon Fold 'N Roll Cart System |
Common Values
| Value | Count | Frequency (%) |
| Staple envelope | 48 | 0.5% |
| Staples | 46 | 0.5% |
| Easy-staple paper | 46 | 0.5% |
| Avery Non-Stick Binders | 20 | 0.2% |
| Staples in misc. colors | 19 | 0.2% |
| Staple remover | 18 | 0.2% |
| KI Adjustable-Height Table | 18 | 0.2% |
| Storex Dura Pro Binders | 17 | 0.2% |
| Staple-based wall hangings | 16 | 0.2% |
| Logitech 910-002974 M325 Wireless Mouse for Web Scrolling | 15 | 0.2% |
| Other values (1840) | 9731 |
Length
| Value | Count | Frequency (%) |
| xerox | 865 | 1.5% |
| x | 701 | 1.3% |
| 599 | 1.1% | |
| with | 599 | 1.1% |
| avery | 557 | 1.0% |
| for | 539 | 1.0% |
| binders | 524 | 0.9% |
| chair | 479 | 0.9% |
| black | 426 | 0.8% |
| phone | 374 | 0.7% |
| Other values (2798) | 50371 |
Most occurring characters
| Value | Count | Frequency (%) |
| 45670 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (75) | 150106 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 238253 | |
| Uppercase Letter | 56270 | 15.3% |
| Space Separator | 46097 | 12.5% |
| Decimal Number | 17981 | 4.9% |
| Other Punctuation | 7152 | 1.9% |
| Dash Punctuation | 2940 | 0.8% |
| Control | 86 | < 0.1% |
| Close Punctuation | 60 | < 0.1% |
| Open Punctuation | 60 | < 0.1% |
| Math Symbol | 35 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 33538 | |
| r | 20791 | 8.7% |
| o | 19902 | 8.4% |
| a | 19064 | 8.0% |
| i | 18648 | 7.8% |
| l | 16365 | 6.9% |
| n | 15622 | 6.6% |
| s | 14683 | 6.2% |
| t | 14550 | 6.1% |
| c | 8924 | 3.7% |
| Other values (18) | 56166 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 6281 | 11.2% |
| C | 6007 | 10.7% |
| B | 5530 | 9.8% |
| P | 4918 | 8.7% |
| A | 2948 | 5.2% |
| D | 2941 | 5.2% |
| M | 2870 | 5.1% |
| T | 2616 | 4.6% |
| F | 2510 | 4.5% |
| L | 2284 | 4.1% |
| Other values (16) | 17365 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 3120 | |
| / | 1561 | |
| " | 1300 | |
| . | 463 | 6.5% |
| & | 287 | 4.0% |
| ' | 257 | 3.6% |
| # | 90 | 1.3% |
| % | 45 | 0.6% |
| * | 9 | 0.1% |
| ! | 9 | 0.1% |
| Other values (2) | 11 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3783 | |
| 0 | 2921 | |
| 2 | 2270 | |
| 4 | 1725 | |
| 3 | 1530 | |
| 5 | 1443 | 8.0% |
| 8 | 1254 | 7.0% |
| 9 | 1234 | 6.9% |
| 6 | 941 | 5.2% |
| 7 | 880 | 4.9% |
Space Separator
| Value | Count | Frequency (%) |
| 45670 | ||
| Â | 427 | 0.9% |
Control
| Value | Count | Frequency (%) |
| ” | 67 | |
| “ | 19 | 22.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2940 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 60 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 60 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 35 |
Other Number
| Value | Count | Frequency (%) |
| ¾ | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 294523 | |
| Common | 74416 | 20.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 33538 | 11.4% |
| r | 20791 | 7.1% |
| o | 19902 | 6.8% |
| a | 19064 | 6.5% |
| i | 18648 | 6.3% |
| l | 16365 | 5.6% |
| n | 15622 | 5.3% |
| s | 14683 | 5.0% |
| t | 14550 | 4.9% |
| c | 8924 | 3.0% |
| Other values (44) | 112436 |
Common
| Value | Count | Frequency (%) |
| 45670 | ||
| 1 | 3783 | 5.1% |
| , | 3120 | 4.2% |
| - | 2940 | 4.0% |
| 0 | 2921 | 3.9% |
| 2 | 2270 | 3.1% |
| 4 | 1725 | 2.3% |
| / | 1561 | 2.1% |
| 3 | 1530 | 2.1% |
| 5 | 1443 | 1.9% |
| Other values (21) | 7453 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 368404 | |
| None | 535 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 45670 | 12.4% | |
| e | 33538 | 9.1% |
| r | 20791 | 5.6% |
| o | 19902 | 5.4% |
| a | 19064 | 5.2% |
| i | 18648 | 5.1% |
| l | 16365 | 4.4% |
| n | 15622 | 4.2% |
| s | 14683 | 4.0% |
| t | 14550 | 3.9% |
| Other values (69) | 149571 |
None
| Value | Count | Frequency (%) |
| Â | 427 | |
| ” | 67 | 12.5% |
| “ | 19 | 3.6% |
| é | 14 | 2.6% |
| ¾ | 5 | 0.9% |
| Ã | 3 | 0.6% |
sales
Real number (ℝ)
| Distinct | 5825 |
|---|---|
| Distinct (%) | 58.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 229.858 |
| Minimum | 0.444 |
|---|---|
| Maximum | 22638.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 0.444 |
|---|---|
| 5-th percentile | 4.98 |
| Q1 | 17.28 |
| median | 54.49 |
| Q3 | 209.94 |
| 95-th percentile | 956.98425 |
| Maximum | 22638.48 |
| Range | 22638.036 |
| Interquartile range (IQR) | 192.66 |
Descriptive statistics
| Standard deviation | 623.2451 |
|---|---|
| Coefficient of variation (CV) | 2.7114353 |
| Kurtosis | 305.31175 |
| Mean | 229.858 |
| Median Absolute Deviation (MAD) | 45.406 |
| Skewness | 12.972752 |
| Sum | 2297200.9 |
| Variance | 388434.46 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.96 | 56 | 0.6% |
| 19.44 | 39 | 0.4% |
| 15.552 | 39 | 0.4% |
| 25.92 | 36 | 0.4% |
| 10.368 | 36 | 0.4% |
| 32.4 | 28 | 0.3% |
| 17.94 | 21 | 0.2% |
| 6.48 | 21 | 0.2% |
| 20.736 | 19 | 0.2% |
| 14.94 | 17 | 0.2% |
| Other values (5815) | 9682 |
| Value | Count | Frequency (%) |
| 0.444 | 1 | < 0.1% |
| 0.556 | 1 | < 0.1% |
| 0.836 | 1 | < 0.1% |
| 0.852 | 1 | < 0.1% |
| 0.876 | 1 | < 0.1% |
| 0.898 | 1 | < 0.1% |
| 0.984 | 1 | < 0.1% |
| 0.99 | 1 | < 0.1% |
| 1.044 | 1 | < 0.1% |
| 1.08 | 3 |
| Value | Count | Frequency (%) |
| 22638.48 | 1 | |
| 17499.95 | 1 | |
| 13999.96 | 1 | |
| 11199.968 | 1 | |
| 10499.97 | 1 | |
| 9892.74 | 1 | |
| 9449.95 | 1 | |
| 9099.93 | 1 | |
| 8749.95 | 1 | |
| 8399.976 | 1 |
quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7895737 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2251097 |
|---|---|
| Coefficient of variation (CV) | 0.58716622 |
| Kurtosis | 1.9918894 |
| Mean | 3.7895737 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.2785448 |
| Sum | 37873 |
| Variance | 4.9511131 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 2409 | |
| 2 | 2402 | |
| 5 | 1230 | |
| 4 | 1191 | |
| 1 | 899 | 9.0% |
| 7 | 606 | 6.1% |
| 6 | 572 | 5.7% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 10 | 57 | 0.6% |
| Other values (4) | 113 | 1.1% |
| Value | Count | Frequency (%) |
| 1 | 899 | 9.0% |
| 2 | 2402 | |
| 3 | 2409 | |
| 4 | 1191 | |
| 5 | 1230 | |
| 6 | 572 | 5.7% |
| 7 | 606 | 6.1% |
| 8 | 257 | 2.6% |
| 9 | 258 | 2.6% |
| 10 | 57 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 29 | 0.3% |
| 13 | 27 | 0.3% |
| 12 | 23 | 0.2% |
| 11 | 34 | 0.3% |
| 10 | 57 | 0.6% |
| 9 | 258 | 2.6% |
| 8 | 257 | 2.6% |
| 7 | 606 | |
| 6 | 572 | |
| 5 | 1230 |
discount
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15620272 |
| Minimum | 0 |
|---|---|
| Maximum | 0.8 |
| Zeros | 4798 |
| Zeros (%) | 48.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.2 |
| 95-th percentile | 0.7 |
| Maximum | 0.8 |
| Range | 0.8 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.20645197 |
|---|---|
| Coefficient of variation (CV) | 1.3216925 |
| Kurtosis | 2.4095461 |
| Mean | 0.15620272 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 1.6842947 |
| Sum | 1561.09 |
| Variance | 0.042622415 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 0.2 | 3657 | |
| 0.7 | 418 | 4.2% |
| 0.8 | 300 | 3.0% |
| 0.3 | 227 | 2.3% |
| 0.4 | 206 | 2.1% |
| 0.6 | 138 | 1.4% |
| 0.1 | 94 | 0.9% |
| 0.5 | 66 | 0.7% |
| 0.15 | 52 | 0.5% |
| Other values (2) | 38 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 4798 | |
| 0.1 | 94 | 0.9% |
| 0.15 | 52 | 0.5% |
| 0.2 | 3657 | |
| 0.3 | 227 | 2.3% |
| 0.32 | 27 | 0.3% |
| 0.4 | 206 | 2.1% |
| 0.45 | 11 | 0.1% |
| 0.5 | 66 | 0.7% |
| 0.6 | 138 | 1.4% |
| Value | Count | Frequency (%) |
| 0.8 | 300 | 3.0% |
| 0.7 | 418 | 4.2% |
| 0.6 | 138 | 1.4% |
| 0.5 | 66 | 0.7% |
| 0.45 | 11 | 0.1% |
| 0.4 | 206 | 2.1% |
| 0.32 | 27 | 0.3% |
| 0.3 | 227 | 2.3% |
| 0.2 | 3657 | |
| 0.15 | 52 | 0.5% |
profit
Real number (ℝ)
| Distinct | 7287 |
|---|---|
| Distinct (%) | 72.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.656896 |
| Minimum | -6599.978 |
|---|---|
| Maximum | 8399.976 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 1871 |
| Negative (%) | 18.7% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | -6599.978 |
|---|---|
| 5-th percentile | -53.03092 |
| Q1 | 1.72875 |
| median | 8.6665 |
| Q3 | 29.364 |
| 95-th percentile | 168.4704 |
| Maximum | 8399.976 |
| Range | 14999.954 |
| Interquartile range (IQR) | 27.63525 |
Descriptive statistics
| Standard deviation | 234.26011 |
|---|---|
| Coefficient of variation (CV) | 8.1746504 |
| Kurtosis | 397.18851 |
| Mean | 28.656896 |
| Median Absolute Deviation (MAD) | 10.77855 |
| Skewness | 7.5614316 |
| Sum | 286397.02 |
| Variance | 54877.798 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 65 | 0.7% |
| 6.2208 | 43 | 0.4% |
| 9.3312 | 38 | 0.4% |
| 5.4432 | 32 | 0.3% |
| 3.6288 | 32 | 0.3% |
| 15.552 | 26 | 0.3% |
| 12.4416 | 21 | 0.2% |
| 7.2576 | 19 | 0.2% |
| 3.1104 | 18 | 0.2% |
| 9.072 | 11 | 0.1% |
| Other values (7277) | 9689 |
| Value | Count | Frequency (%) |
| -6599.978 | 1 | |
| -3839.9904 | 1 | |
| -3701.8928 | 1 | |
| -3399.98 | 1 | |
| -2929.4845 | 1 | |
| -2639.9912 | 1 | |
| -2287.782 | 1 | |
| -1862.3124 | 1 | |
| -1850.9464 | 1 | |
| -1811.0784 | 1 |
| Value | Count | Frequency (%) |
| 8399.976 | 1 | |
| 6719.9808 | 1 | |
| 5039.9856 | 1 | |
| 4946.37 | 1 | |
| 4630.4755 | 1 | |
| 3919.9888 | 1 | |
| 3177.475 | 1 | |
| 2799.984 | 1 | |
| 2591.9568 | 1 | |
| 2504.2216 | 1 |
no_of_days_for_shipping
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9581749 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 519 |
| Zeros (%) | 5.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7475667 |
|---|---|
| Coefficient of variation (CV) | 0.44150822 |
| Kurtosis | -0.28755198 |
| Mean | 3.9581749 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.42132235 |
| Sum | 39558 |
| Variance | 3.0539895 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 2774 | |
| 5 | 2169 | |
| 2 | 1334 | |
| 6 | 1203 | |
| 3 | 1005 | 10.1% |
| 7 | 621 | 6.2% |
| 0 | 519 | 5.2% |
| 1 | 369 | 3.7% |
| Value | Count | Frequency (%) |
| 0 | 519 | 5.2% |
| 1 | 369 | 3.7% |
| 2 | 1334 | |
| 3 | 1005 | 10.1% |
| 4 | 2774 | |
| 5 | 2169 | |
| 6 | 1203 | |
| 7 | 621 | 6.2% |
| Value | Count | Frequency (%) |
| 7 | 621 | 6.2% |
| 6 | 1203 | |
| 5 | 2169 | |
| 4 | 2774 | |
| 3 | 1005 | 10.1% |
| 2 | 1334 | |
| 1 | 369 | 3.7% |
| 0 | 519 | 5.2% |
sale_price_per_unit
Real number (ℝ)
| Distinct | 5006 |
|---|---|
| Distinct (%) | 50.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.862121 |
| Minimum | -0.356 |
|---|---|
| Maximum | 3772.9967 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | -0.356 |
|---|---|
| 5-th percentile | 1.82 |
| Q1 | 5.402 |
| median | 16.236 |
| Q3 | 63.8845 |
| 95-th percentile | 243.9618 |
| Maximum | 3772.9967 |
| Range | 3773.3527 |
| Interquartile range (IQR) | 58.4825 |
Descriptive statistics
| Standard deviation | 142.93014 |
|---|---|
| Coefficient of variation (CV) | 2.3484253 |
| Kurtosis | 197.79112 |
| Mean | 60.862121 |
| Median Absolute Deviation (MAD) | 13.333 |
| Skewness | 10.78231 |
| Sum | 608256.04 |
| Variance | 20429.026 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.48 | 158 | 1.6% |
| 5.98 | 49 | 0.5% |
| 5.117333333 | 39 | 0.4% |
| 6.48 | 38 | 0.4% |
| 2.88 | 36 | 0.4% |
| 5.084 | 36 | 0.4% |
| 6.68 | 33 | 0.3% |
| 4.13 | 32 | 0.3% |
| 29.99 | 30 | 0.3% |
| 4.28 | 30 | 0.3% |
| Other values (4996) | 9513 |
| Value | Count | Frequency (%) |
| -0.356 | 1 | |
| -0.244 | 1 | |
| 0.036 | 1 | |
| 0.076 | 1 | |
| 0.092 | 1 | |
| 0.09333333333 | 1 | |
| 0.098 | 1 | |
| 0.136 | 1 | |
| 0.1493333333 | 1 | |
| 0.152 | 1 |
| Value | Count | Frequency (%) |
| 3772.996667 | 1 | |
| 3499.99 | 1 | |
| 3499.99 | 2 | |
| 2799.942 | 1 | |
| 2399.892 | 1 | |
| 2099.894 | 1 | |
| 1999.87 | 1 | |
| 1995.99 | 1 | |
| 1889.99 | 1 | |
| 1749.99 | 1 |
profit_per_unit
Real number (ℝ)
| Distinct | 4246 |
|---|---|
| Distinct (%) | 42.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7993719 |
| Minimum | -1319.9956 |
|---|---|
| Maximum | 1679.9952 |
| Zeros | 65 |
| Zeros (%) | 0.7% |
| Negative | 1871 |
| Negative (%) | 18.7% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | -1319.9956 |
|---|---|
| 5-th percentile | -15.7514 |
| Q1 | 0.7228 |
| median | 2.767 |
| Q3 | 8.7032 |
| 95-th percentile | 44.9985 |
| Maximum | 1679.9952 |
| Range | 2999.9908 |
| Interquartile range (IQR) | 7.9804 |
Descriptive statistics
| Standard deviation | 56.074974 |
|---|---|
| Coefficient of variation (CV) | 7.1896781 |
| Kurtosis | 355.61647 |
| Mean | 7.7993719 |
| Median Absolute Deviation (MAD) | 3.1531 |
| Skewness | 7.6224049 |
| Sum | 77946.923 |
| Variance | 3144.4027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.1104 | 125 | 1.3% |
| 1.8144 | 104 | 1.0% |
| 0 | 65 | 0.7% |
| 3.1104 | 51 | 0.5% |
| 3.2064 | 25 | 0.3% |
| 7.745 | 23 | 0.2% |
| 5.7716 | 22 | 0.2% |
| 0.9512 | 22 | 0.2% |
| 1.4112 | 22 | 0.2% |
| 3.4357 | 21 | 0.2% |
| Other values (4236) | 9514 |
| Value | Count | Frequency (%) |
| -1319.9956 | 2 | |
| -959.9976 | 1 | |
| -679.996 | 1 | |
| -585.8969 | 1 | |
| -462.7366 | 2 | |
| -381.297 | 2 | |
| -326.6376 | 1 | |
| -314.9982 | 1 | |
| -301.8464 | 1 | |
| -296.0067 | 1 |
| Value | Count | Frequency (%) |
| 1679.9952 | 3 | |
| 997.995 | 1 | < 0.1% |
| 979.9972 | 1 | < 0.1% |
| 926.0951 | 1 | < 0.1% |
| 635.495 | 4 | |
| 626.0554 | 1 | < 0.1% |
| 559.9968 | 2 | < 0.1% |
| 557.256 | 2 | < 0.1% |
| 548.0971 | 1 | < 0.1% |
| 421.5853 | 5 |
purchase_price_per_unit
Real number (ℝ)
| Distinct | 6078 |
|---|---|
| Distinct (%) | 60.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53.062749 |
| Minimum | 0.4544 |
|---|---|
| Maximum | 4074.8431 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 0.4544 |
|---|---|
| 5-th percentile | 1.60808 |
| Q1 | 3.4324 |
| median | 12.7859 |
| Q3 | 54.522 |
| 95-th percentile | 217.4069 |
| Maximum | 4074.8431 |
| Range | 4074.3887 |
| Interquartile range (IQR) | 51.0896 |
Descriptive statistics
| Standard deviation | 122.24696 |
|---|---|
| Coefficient of variation (CV) | 2.3038188 |
| Kurtosis | 217.50886 |
| Mean | 53.062749 |
| Median Absolute Deviation (MAD) | 10.471833 |
| Skewness | 10.707819 |
| Sum | 530309.12 |
| Variance | 14944.319 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.3696 | 89 | 0.9% |
| 3.3696 | 51 | 0.5% |
| 3.3696 | 36 | 0.4% |
| 3.2696 | 32 | 0.3% |
| 3.302933333 | 32 | 0.3% |
| 3.4736 | 25 | 0.3% |
| 3.8743 | 21 | 0.2% |
| 17.039 | 20 | 0.2% |
| 3.3196 | 19 | 0.2% |
| 6.5084 | 19 | 0.2% |
| Other values (6068) | 9650 |
| Value | Count | Frequency (%) |
| 0.4544 | 1 | |
| 0.4778333333 | 2 | |
| 0.5042 | 1 | |
| 0.5258285714 | 1 | |
| 0.5445 | 2 | |
| 0.5445 | 1 | |
| 0.5544 | 2 | |
| 0.5544 | 1 | |
| 0.5572 | 1 | |
| 0.5708666667 | 1 |
| Value | Count | Frequency (%) |
| 4074.843067 | 1 | |
| 2959.8676 | 1 | |
| 2219.8926 | 1 | |
| 2219.8526 | 1 | |
| 2219.6426 | 1 | |
| 1819.9948 | 1 | |
| 1819.9948 | 2 | |
| 1819.9448 | 1 | |
| 1819.8948 | 1 | |
| 1572.0288 | 2 |
purchase_price
Real number (ℝ)
| Distinct | 7642 |
|---|---|
| Distinct (%) | 76.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 201.0449 |
| Minimum | 0.5544 |
|---|---|
| Maximum | 24449.058 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 0.5544 |
|---|---|
| 5-th percentile | 3.8964 |
| Q1 | 12.4967 |
| median | 41.577 |
| Q3 | 181.9095 |
| 95-th percentile | 862.80072 |
| Maximum | 24449.058 |
| Range | 24448.504 |
| Interquartile range (IQR) | 169.4128 |
Descriptive statistics
| Standard deviation | 550.82677 |
|---|---|
| Coefficient of variation (CV) | 2.7398196 |
| Kurtosis | 454.60542 |
| Mean | 201.0449 |
| Median Absolute Deviation (MAD) | 35.1384 |
| Skewness | 14.753314 |
| Sum | 2009242.7 |
| Variance | 303410.13 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.7392 | 43 | 0.4% |
| 10.1088 | 38 | 0.4% |
| 9.9088 | 32 | 0.3% |
| 6.5392 | 32 | 0.3% |
| 16.848 | 26 | 0.3% |
| 13.4784 | 21 | 0.2% |
| 13.2784 | 19 | 0.2% |
| 3.3696 | 18 | 0.2% |
| 20.0176 | 10 | 0.1% |
| 7.7486 | 10 | 0.1% |
| Other values (7632) | 9745 |
| Value | Count | Frequency (%) |
| 0.5544 | 1 | |
| 0.64 | 2 | |
| 0.6572 | 1 | |
| 0.6736 | 1 | |
| 0.7012 | 1 | |
| 0.736 | 1 | |
| 0.7484 | 1 | |
| 0.754 | 1 | |
| 0.84 | 1 | |
| 0.8812 | 1 |
| Value | Count | Frequency (%) |
| 24449.0584 | 1 | |
| 11839.4704 | 1 | |
| 11099.263 | 1 | |
| 9519.544 | 1 | |
| 9099.974 | 1 | |
| 7860.144 | 1 | |
| 7279.9792 | 1 | |
| 7279.7792 | 1 | |
| 7279.5792 | 1 | |
| 6733.9482 | 1 |
weekday_string
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 962.7 KiB |
| Wednesday | |
|---|---|
| Tuesday | |
| Friday | |
| Saturday | |
| Thursday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.2040224 |
| Min length | 6 |
Characters and Unicode
| Total characters | 71997 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Friday |
|---|---|
| 2nd row | Friday |
| 3rd row | Thursday |
| 4th row | Sunday |
| 5th row | Sunday |
Common Values
| Value | Count | Frequency (%) |
| Wednesday | 1593 | |
| Tuesday | 1566 | |
| Friday | 1562 | |
| Saturday | 1429 | |
| Thursday | 1415 | |
| Monday | 1241 | |
| Sunday | 1188 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wednesday | 1593 | |
| tuesday | 1566 | |
| friday | 1562 | |
| saturday | 1429 | |
| thursday | 1415 | |
| monday | 1241 | |
| sunday | 1188 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 11587 | |
| a | 11423 | |
| y | 9994 | |
| u | 5598 | |
| e | 4752 | |
| s | 4574 | 6.4% |
| r | 4406 | 6.1% |
| n | 4022 | 5.6% |
| T | 2981 | 4.1% |
| S | 2617 | 3.6% |
| Other values (7) | 10043 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 62003 | |
| Uppercase Letter | 9994 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 11587 | |
| a | 11423 | |
| y | 9994 | |
| u | 5598 | |
| e | 4752 | |
| s | 4574 | 7.4% |
| r | 4406 | 7.1% |
| n | 4022 | 6.5% |
| i | 1562 | 2.5% |
| t | 1429 | 2.3% |
| Other values (2) | 2656 | 4.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 2981 | |
| S | 2617 | |
| W | 1593 | |
| F | 1562 | |
| M | 1241 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 71997 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 11587 | |
| a | 11423 | |
| y | 9994 | |
| u | 5598 | |
| e | 4752 | |
| s | 4574 | 6.4% |
| r | 4406 | 6.1% |
| n | 4022 | 5.6% |
| T | 2981 | 4.1% |
| S | 2617 | 3.6% |
| Other values (7) | 10043 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 71997 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 11587 | |
| a | 11423 | |
| y | 9994 | |
| u | 5598 | |
| e | 4752 | |
| s | 4574 | 6.4% |
| r | 4406 | 6.1% |
| n | 4022 | 5.6% |
| T | 2981 | 4.1% |
| S | 2617 | 3.6% |
| Other values (7) | 10043 |
year
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 931.5 KiB |
| 2017 | |
|---|---|
| 2016 | |
| 2015 | |
| 2014 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 39976 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2016 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2016 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2017 | 3345 | |
| 2016 | 2578 | |
| 2015 | 2131 | |
| 2014 | 1940 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2017 | 3345 | |
| 2016 | 2578 | |
| 2015 | 2131 | |
| 2014 | 1940 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3345 | 8.4% |
| 6 | 2578 | 6.4% |
| 5 | 2131 | 5.3% |
| 4 | 1940 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39976 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3345 | 8.4% |
| 6 | 2578 | 6.4% |
| 5 | 2131 | 5.3% |
| 4 | 1940 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 39976 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3345 | 8.4% |
| 6 | 2578 | 6.4% |
| 5 | 2131 | 5.3% |
| 4 | 1940 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39976 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 9994 | |
| 0 | 9994 | |
| 1 | 9994 | |
| 7 | 3345 | 8.4% |
| 6 | 2578 | 6.4% |
| 5 | 2131 | 5.3% |
| 4 | 1940 | 4.9% |
month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.7893736 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 414.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 9 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3229042 |
|---|---|
| Coefficient of variation (CV) | 0.42659453 |
| Kurtosis | -0.98257695 |
| Mean | 7.7893736 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.4376743 |
| Sum | 77847 |
| Variance | 11.041692 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 1449 | |
| 11 | 1436 | |
| 9 | 1356 | |
| 10 | 831 | |
| 6 | 764 | |
| 7 | 721 | |
| 5 | 694 | |
| 8 | 674 | |
| 4 | 653 | |
| 3 | 652 | |
| Other values (2) | 764 |
| Value | Count | Frequency (%) |
| 1 | 440 | 4.4% |
| 2 | 324 | 3.2% |
| 3 | 652 | |
| 4 | 653 | |
| 5 | 694 | |
| 6 | 764 | |
| 7 | 721 | |
| 8 | 674 | |
| 9 | 1356 | |
| 10 | 831 |
| Value | Count | Frequency (%) |
| 12 | 1449 | |
| 11 | 1436 | |
| 10 | 831 | |
| 9 | 1356 | |
| 8 | 674 | |
| 7 | 721 | |
| 6 | 764 | |
| 5 | 694 | |
| 4 | 653 | |
| 3 | 652 |
month_name
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 956.3 KiB |
| December | |
|---|---|
| November | |
| September | |
| October | |
| June | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.5403242 |
| Min length | 3 |
Characters and Unicode
| Total characters | 65364 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | November |
|---|---|
| 2nd row | November |
| 3rd row | June |
| 4th row | October |
| 5th row | October |
Common Values
| Value | Count | Frequency (%) |
| December | 1449 | |
| November | 1436 | |
| September | 1356 | |
| October | 831 | |
| June | 764 | |
| July | 721 | |
| May | 694 | |
| August | 674 | |
| April | 653 | |
| March | 652 | |
| Other values (2) | 764 |
Length
| Value | Count | Frequency (%) |
| december | 1449 | |
| november | 1436 | |
| september | 1356 | |
| october | 831 | |
| june | 764 | |
| july | 721 | |
| may | 694 | |
| august | 674 | |
| april | 653 | |
| march | 652 | |
| Other values (2) | 764 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13206 | |
| r | 7465 | 11.4% |
| b | 5396 | 8.3% |
| m | 4241 | 6.5% |
| u | 3597 | 5.5% |
| c | 2932 | 4.5% |
| t | 2861 | 4.4% |
| a | 2550 | 3.9% |
| o | 2267 | 3.5% |
| y | 2179 | 3.3% |
| Other values (16) | 18670 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 55370 | |
| Uppercase Letter | 9994 | 15.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 13206 | |
| r | 7465 | |
| b | 5396 | |
| m | 4241 | 7.7% |
| u | 3597 | 6.5% |
| c | 2932 | 5.3% |
| t | 2861 | 5.2% |
| a | 2550 | 4.6% |
| o | 2267 | 4.1% |
| y | 2179 | 3.9% |
| Other values (8) | 8676 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 1925 | |
| D | 1449 | |
| N | 1436 | |
| S | 1356 | |
| M | 1346 | |
| A | 1327 | |
| O | 831 | |
| F | 324 | 3.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 65364 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 13206 | |
| r | 7465 | 11.4% |
| b | 5396 | 8.3% |
| m | 4241 | 6.5% |
| u | 3597 | 5.5% |
| c | 2932 | 4.5% |
| t | 2861 | 4.4% |
| a | 2550 | 3.9% |
| o | 2267 | 3.5% |
| y | 2179 | 3.3% |
| Other values (16) | 18670 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 65364 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 13206 | |
| r | 7465 | 11.4% |
| b | 5396 | 8.3% |
| m | 4241 | 6.5% |
| u | 3597 | 5.5% |
| c | 2932 | 4.5% |
| t | 2861 | 4.4% |
| a | 2550 | 3.9% |
| o | 2267 | 3.5% |
| y | 2179 | 3.3% |
| Other values (16) | 18670 |
| sales | quantity | discount | profit | no_of_days_for_shipping | sale_price_per_unit | profit_per_unit | purchase_price_per_unit | purchase_price | month | ship_mode | segment | state | region | category | sub-category | weekday_string | year | month_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sales | 1.000 | 0.327 | -0.057 | 0.518 | -0.015 | 0.935 | 0.470 | 0.911 | 0.976 | 0.016 | 0.000 | 0.002 | 0.000 | 0.000 | 0.072 | 0.142 | 0.012 | 0.000 | 0.008 |
| quantity | 0.327 | 1.000 | -0.001 | 0.234 | 0.016 | -0.007 | 0.000 | -0.005 | 0.321 | 0.024 | 0.000 | 0.012 | 0.004 | 0.000 | 0.000 | 0.000 | 0.001 | 0.015 | 0.011 |
| discount | -0.057 | -0.001 | 1.000 | -0.543 | -0.014 | -0.070 | -0.553 | 0.087 | 0.088 | -0.002 | 0.027 | 0.005 | 0.354 | 0.294 | 0.377 | 0.353 | 0.017 | 0.000 | 0.007 |
| profit | 0.518 | 0.234 | -0.543 | 1.000 | -0.007 | 0.460 | 0.953 | 0.324 | 0.385 | 0.016 | 0.005 | 0.000 | 0.017 | 0.021 | 0.056 | 0.130 | 0.006 | 0.000 | 0.000 |
| no_of_days_for_shipping | -0.015 | 0.016 | -0.014 | -0.007 | 1.000 | -0.024 | -0.015 | -0.023 | -0.014 | 0.004 | 0.781 | 0.043 | 0.102 | 0.041 | 0.000 | 0.001 | 0.141 | 0.046 | 0.053 |
| sale_price_per_unit | 0.935 | -0.007 | -0.070 | 0.460 | -0.024 | 1.000 | 0.505 | 0.972 | 0.913 | 0.008 | 0.019 | 0.000 | 0.026 | 0.000 | 0.099 | 0.186 | 0.007 | 0.008 | 0.012 |
| profit_per_unit | 0.470 | 0.000 | -0.553 | 0.953 | -0.015 | 0.505 | 1.000 | 0.367 | 0.339 | 0.012 | 0.014 | 0.000 | 0.041 | 0.022 | 0.068 | 0.164 | 0.014 | 0.000 | 0.014 |
| purchase_price_per_unit | 0.911 | -0.005 | 0.087 | 0.324 | -0.023 | 0.972 | 0.367 | 1.000 | 0.938 | 0.006 | 0.022 | 0.000 | 0.000 | 0.010 | 0.062 | 0.176 | 0.015 | 0.000 | 0.013 |
| purchase_price | 0.976 | 0.321 | 0.088 | 0.385 | -0.014 | 0.913 | 0.339 | 0.938 | 1.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.005 | 0.045 | 0.128 | 0.012 | 0.000 | 0.000 |
| month | 0.016 | 0.024 | -0.002 | 0.016 | 0.004 | 0.008 | 0.012 | 0.006 | 0.014 | 1.000 | 0.049 | 0.036 | 0.097 | 0.043 | 0.000 | 0.000 | 0.049 | 0.021 | 1.000 |
| ship_mode | 0.000 | 0.000 | 0.027 | 0.005 | 0.781 | 0.019 | 0.014 | 0.022 | 0.000 | 0.049 | 1.000 | 0.033 | 0.096 | 0.022 | 0.000 | 0.007 | 0.105 | 0.021 | 0.050 |
| segment | 0.002 | 0.012 | 0.005 | 0.000 | 0.043 | 0.000 | 0.000 | 0.000 | 0.000 | 0.036 | 0.033 | 1.000 | 0.090 | 0.000 | 0.000 | 0.000 | 0.038 | 0.027 | 0.037 |
| state | 0.000 | 0.004 | 0.354 | 0.017 | 0.102 | 0.026 | 0.041 | 0.000 | 0.000 | 0.097 | 0.096 | 0.090 | 1.000 | 0.998 | 0.019 | 0.000 | 0.103 | 0.089 | 0.101 |
| region | 0.000 | 0.000 | 0.294 | 0.021 | 0.041 | 0.000 | 0.022 | 0.010 | 0.005 | 0.043 | 0.022 | 0.000 | 0.998 | 1.000 | 0.000 | 0.000 | 0.060 | 0.021 | 0.046 |
| category | 0.072 | 0.000 | 0.377 | 0.056 | 0.000 | 0.099 | 0.068 | 0.062 | 0.045 | 0.000 | 0.000 | 0.000 | 0.019 | 0.000 | 1.000 | 0.999 | 0.000 | 0.000 | 0.000 |
| sub-category | 0.142 | 0.000 | 0.353 | 0.130 | 0.001 | 0.186 | 0.164 | 0.176 | 0.128 | 0.000 | 0.007 | 0.000 | 0.000 | 0.000 | 0.999 | 1.000 | 0.000 | 0.000 | 0.000 |
| weekday_string | 0.012 | 0.001 | 0.017 | 0.006 | 0.141 | 0.007 | 0.014 | 0.015 | 0.012 | 0.049 | 0.105 | 0.038 | 0.103 | 0.060 | 0.000 | 0.000 | 1.000 | 0.046 | 0.053 |
| year | 0.000 | 0.015 | 0.000 | 0.000 | 0.046 | 0.008 | 0.000 | 0.000 | 0.000 | 0.021 | 0.021 | 0.027 | 0.089 | 0.021 | 0.000 | 0.000 | 0.046 | 1.000 | 0.028 |
| month_name | 0.008 | 0.011 | 0.007 | 0.000 | 0.053 | 0.012 | 0.014 | 0.013 | 0.000 | 1.000 | 0.050 | 0.037 | 0.101 | 0.046 | 0.000 | 0.000 | 0.053 | 0.028 | 1.000 |
| order_id | order_date | ship_date | ship_mode | customer_id | customer_name | segment | city | state | region | product_id | category | sub-category | product_name | sales | quantity | discount | profit | no_of_days_for_shipping | sale_price_per_unit | profit_per_unit | purchase_price_per_unit | purchase_price | weekday_string | year | month | month_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CA-2016-152156 | 2016-11-08 | 2016-11-11 | Second Class | CG-12520 | Claire Gute | Consumer | Henderson | Kentucky | South | FUR-BO-10001798 | Furniture | Bookcases | Bush Somerset Collection Bookcase | 261.96000 | 2 | 0.00000 | 41.91360 | 3 | 130.98000 | 20.95680 | 110.02320 | 220.04640 | Friday | 2016 | 11 | November |
| 1 | CA-2016-152156 | 2016-11-08 | 2016-11-11 | Second Class | CG-12520 | Claire Gute | Consumer | Henderson | Kentucky | South | FUR-CH-10000454 | Furniture | Chairs | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 731.94000 | 3 | 0.00000 | 219.58200 | 3 | 243.98000 | 73.19400 | 170.78600 | 512.35800 | Friday | 2016 | 11 | November |
| 2 | CA-2016-138688 | 2016-06-12 | 2016-06-16 | Second Class | DV-13045 | Darrin Van Huff | Corporate | Los Angeles | California | West | OFF-LA-10000240 | Office Supplies | Labels | Self-Adhesive Address Labels for Typewriters by Universal | 14.62000 | 2 | 0.00000 | 6.87140 | 4 | 7.31000 | 3.43570 | 3.87430 | 7.74860 | Thursday | 2016 | 6 | June |
| 3 | US-2015-108966 | 2015-10-11 | 2015-10-18 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | Fort Lauderdale | Florida | South | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 957.57750 | 5 | 0.45000 | -383.03100 | 7 | 191.42550 | -76.60620 | 268.03170 | 1340.15850 | Sunday | 2015 | 10 | October |
| 4 | US-2015-108966 | 2015-10-11 | 2015-10-18 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | Fort Lauderdale | Florida | South | OFF-ST-10000760 | Office Supplies | Storage | Eldon Fold 'N Roll Cart System | 22.36800 | 2 | 0.20000 | 2.51640 | 7 | 11.08400 | 1.25820 | 9.82580 | 19.65160 | Sunday | 2015 | 10 | October |
| 5 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | Los Angeles | California | West | FUR-FU-10001487 | Furniture | Furnishings | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood | 48.86000 | 7 | 0.00000 | 14.16940 | 5 | 6.98000 | 2.02420 | 4.95580 | 34.69060 | Saturday | 2014 | 6 | June |
| 6 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | Los Angeles | California | West | OFF-AR-10002833 | Office Supplies | Art | Newell 322 | 7.28000 | 4 | 0.00000 | 1.96560 | 5 | 1.82000 | 0.49140 | 1.32860 | 5.31440 | Saturday | 2014 | 6 | June |
| 7 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | Los Angeles | California | West | TEC-PH-10002275 | Technology | Phones | Mitel 5320 IP Phone VoIP phone | 907.15200 | 6 | 0.20000 | 90.71520 | 5 | 151.15867 | 15.11920 | 136.03947 | 816.23680 | Saturday | 2014 | 6 | June |
| 8 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | Los Angeles | California | West | OFF-BI-10003910 | Office Supplies | Binders | DXL Angle-View Binders with Locking Rings by Samsill | 18.50400 | 3 | 0.20000 | 5.78250 | 5 | 6.10133 | 1.92750 | 4.17383 | 12.52150 | Saturday | 2014 | 6 | June |
| 9 | CA-2014-115812 | 2014-06-09 | 2014-06-14 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | Los Angeles | California | West | OFF-AP-10002892 | Office Supplies | Appliances | Belkin F5C206VTEL 6 Outlet Surge | 114.90000 | 5 | 0.00000 | 34.47000 | 5 | 22.98000 | 6.89400 | 16.08600 | 80.43000 | Saturday | 2014 | 6 | June |
| order_id | order_date | ship_date | ship_mode | customer_id | customer_name | segment | city | state | region | product_id | category | sub-category | product_name | sales | quantity | discount | profit | no_of_days_for_shipping | sale_price_per_unit | profit_per_unit | purchase_price_per_unit | purchase_price | weekday_string | year | month | month_name | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9984 | CA-2015-100251 | 2015-05-17 | 2015-05-23 | Standard Class | DV-13465 | Dianna Vittorini | Consumer | Long Beach | New York | East | OFF-LA-10003766 | Office Supplies | Labels | Self-Adhesive Removable Labels | 31.50000 | 10 | 0.00000 | 15.12000 | 6 | 3.15000 | 1.51200 | 1.63800 | 16.38000 | Saturday | 2015 | 5 | May |
| 9985 | CA-2015-100251 | 2015-05-17 | 2015-05-23 | Standard Class | DV-13465 | Dianna Vittorini | Consumer | Long Beach | New York | East | OFF-SU-10000898 | Office Supplies | Supplies | Acme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L | 55.60000 | 4 | 0.00000 | 16.12400 | 6 | 13.90000 | 4.03100 | 9.86900 | 39.47600 | Saturday | 2015 | 5 | May |
| 9986 | CA-2016-125794 | 2016-09-29 | 2016-10-03 | Standard Class | ML-17410 | Maris LaWare | Consumer | Los Angeles | California | West | TEC-AC-10003399 | Technology | Accessories | Memorex Mini Travel Drive 64 GB USB 2.0 Flash Drive | 36.24000 | 1 | 0.00000 | 15.22080 | 4 | 36.24000 | 15.22080 | 21.01920 | 21.01920 | Monday | 2016 | 10 | October |
| 9987 | CA-2017-163629 | 2017-11-17 | 2017-11-21 | Standard Class | RA-19885 | Ruben Ausman | Corporate | Athens | Georgia | South | TEC-AC-10001539 | Technology | Accessories | Logitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology | 79.99000 | 1 | 0.00000 | 28.79640 | 4 | 79.99000 | 28.79640 | 51.19360 | 51.19360 | Tuesday | 2017 | 11 | November |
| 9988 | CA-2017-163629 | 2017-11-17 | 2017-11-21 | Standard Class | RA-19885 | Ruben Ausman | Corporate | Athens | Georgia | South | TEC-PH-10004006 | Technology | Phones | Panasonic KX - TS880B Telephone | 206.10000 | 5 | 0.00000 | 55.64700 | 4 | 41.22000 | 11.12940 | 30.09060 | 150.45300 | Tuesday | 2017 | 11 | November |
| 9989 | CA-2014-110422 | 2014-01-21 | 2014-01-23 | Second Class | TB-21400 | Tom Boeckenhauer | Consumer | Miami | Florida | South | FUR-FU-10001889 | Furniture | Furnishings | Ultra Door Pull Handle | 25.24800 | 3 | 0.20000 | 4.10280 | 2 | 8.34933 | 1.36760 | 6.98173 | 20.94520 | Thursday | 2014 | 1 | January |
| 9990 | CA-2017-121258 | 2017-02-26 | 2017-03-03 | Standard Class | DB-13060 | Dave Brooks | Consumer | Costa Mesa | California | West | FUR-FU-10000747 | Furniture | Furnishings | Tenex B1-RE Series Chair Mats for Low Pile Carpets | 91.96000 | 2 | 0.00000 | 15.63320 | 5 | 45.98000 | 7.81660 | 38.16340 | 76.32680 | Friday | 2017 | 3 | March |
| 9991 | CA-2017-121258 | 2017-02-26 | 2017-03-03 | Standard Class | DB-13060 | Dave Brooks | Consumer | Costa Mesa | California | West | TEC-PH-10003645 | Technology | Phones | Aastra 57i VoIP phone | 258.57600 | 2 | 0.20000 | 19.39320 | 5 | 129.18800 | 9.69660 | 119.49140 | 238.98280 | Friday | 2017 | 3 | March |
| 9992 | CA-2017-121258 | 2017-02-26 | 2017-03-03 | Standard Class | DB-13060 | Dave Brooks | Consumer | Costa Mesa | California | West | OFF-PA-10004041 | Office Supplies | Paper | It's Hot Message Books with Stickers, 2 3/4" x 5" | 29.60000 | 4 | 0.00000 | 13.32000 | 5 | 7.40000 | 3.33000 | 4.07000 | 16.28000 | Friday | 2017 | 3 | March |
| 9993 | CA-2017-119914 | 2017-05-04 | 2017-05-09 | Second Class | CC-12220 | Chris Cortes | Consumer | Westminster | California | West | OFF-AP-10002684 | Office Supplies | Appliances | Acco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection | 243.16000 | 2 | 0.00000 | 72.94800 | 5 | 121.58000 | 36.47400 | 85.10600 | 170.21200 | Tuesday | 2017 | 5 | May |
Most frequently occurring
| order_id | order_date | ship_date | ship_mode | customer_id | customer_name | segment | city | state | region | product_id | category | sub-category | product_name | sales | quantity | discount | profit | no_of_days_for_shipping | sale_price_per_unit | profit_per_unit | purchase_price_per_unit | purchase_price | weekday_string | year | month | month_name | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | US-2014-150119 | 2014-04-23 | 2014-04-27 | Standard Class | LB-16795 | Laurel Beltran | Home Office | Columbus | Ohio | East | FUR-CH-10002965 | Furniture | Chairs | Global Leather Highback Executive Chair with Pneumatic Height Adjustment, Black | 281.37200 | 2 | 0.30000 | -12.05880 | 4 | 140.53600 | -6.02940 | 146.56540 | 293.13080 | Sunday | 2014 | 4 | April | 2 |